Run Report – TimeCard

TimeCard reports allow you to view and print reports about employee timecard entries. These reports aid management in overseeing and analyzing labor utilization and costs. TimeCard reports can be generated by employee, property, or company, for any specified date range.

Your security rights determine whether you can run timecard reports for a particular employee. Manager-Employee relationships allow you to access timecard data for a specified set of employees. Payroll Admin rights allow you to access timecard data for all employees. If you do not have the required security rights, contact your system administrator.

To run TimeCard reports:

Access the TimeCard module by clicking the TimeCard link at the top of the page.
Select the Run Report tab.
In the Select a report field, select the report you want to run.
Specify report criteria.
Click OK to run the report.

The following TimeCard reports are available:

TimeCard Print Timesheet

The TimeCard Print Timesheet report allows you to print timesheets indicating the number of hours worked during a specified date range.

Report Criteria

To refine your results, specify any of the following criteria. If no criteria are specified, the report will be run for all values.

Date Range – Select the date range for which the report will be run. The system uses the previous week as the default date range.
Employee – Select a name from the drop-down menu to run the report for a particular employee.

Report Output

This report generates HTML timesheets for the selected employees. Each timesheet contains one row for each day in the specified date range and indicates the number of hours allocated to each labor rate category, as well as the total number of hours in each day, week, and category. The results include:

Day – the day of the week
Date – the calendar date
REG – the number of hours paid at the regular rate
OT – the number of hours paid at the overtime rate
DT – the number of hours paid at the double-time rate
PTO – the number of hours paid at the Paid Time Off rate
On Site – the number of hours worked on-site
Total – the total number of hours for the specified day

TimeCard Hours Detail

The TimeCard Hours Detail report lists timecard entries for selected employees over a specified date range, broken down by work order and manually entered time.

Report Criteria

To refine your results, specify any of the following criteria. If no criteria are specified, the report will be run for all values.

Region – Select a value to run the report for a particular region. Selecting a region limits the property values that can be selected to the properties within the specified region.
Property – Select a value to run the report for a particular property. If a region was selected, only properties within that region are displayed.
Company – Click the link to run the report for a particular company.
Employee – Select a name from the drop-down menu to run the report for a particular employee.
Manager – Select a name from the drop-down menu to run the report for a particular manager. The possible values are all users who have a manager relationship established with the specified employees.
Cost Center – Enter a value to run the report for a particular cost center. The value you enter must exactly match a valid cost center as specified on the Enter Hours page.
User Group – Select a value from the drop-down menu to run the report for a particular group of users.
Date Range – Select the date range for which the report will be run. The system uses the previous week as the default date range.
Include Manager Detail? – Select Yes to include a hierarchical list of the employee's managers in the results.

Report Output

The generated report contains one row for each timecard entry. The results include:

Manager 1 through N – if manager detail is included in the report, several columns list the names of the employee's managers
Employee – the name of the employee that the time entry is associated with
Employee ID – the External Employee ID as defined in the user's profile
Work Order – the work order the time entry is associated with, or no value if the entry is for manually entered time
Property – the property that the time entry is associated with
Comment – the comment entered when the time entry was made
Date – the date on which the time entry was made
Activity – the activity selected when the time entry was made
Cost Center – the cost center selected when the time entry was made, or, if no selection was made, the automatic cost center
Start Time – for work order time entries only, the value entered for Time Started
End Time – for work order time entries only, the value entered for Time Finished
REG Hours – the number of hours paid at the regular rate
OT Hours – the number of hours paid at the overtime rate
DT Hours – the number of hours paid at the double-time rate
PTO Hours – the number of hours paid at the Paid Time Off rate
On Site – the number of hours worked on-siteOn Site

Time Card Hours by Employee

The TimeCard Hours by Employee report lists a summary of all hours worked during a specified date range, sorted by employee.

Report Criteria

To refine your results, specify any of the following criteria. If no criteria are specified, the report will be run for all values.

Region – Select a value to run the report for a particular region. Selecting a region limits the property values that can be selected to the properties within the specified region.
Property – Select a value to run the report for a particular property. If a region was selected, only properties within that region are displayed.
Company – Click the link to run the report for a particular company.
Employee – Select a name from the drop-down menu to run the report for a particular employee.
Cost Center – Enter a value to run the report for a particular cost center. The value you enter must exactly match a valid cost center as specified on the Enter Hours page.
User Group – Select a value from the drop-down menu to run the report for a particular group of users.
Date Range – Select the date range for which the report will be run. The system uses the previous week as the default date range.
Run in Update Mode? – Select Yes to lock all of the timecards returned by the report. Locked timecards cannot be updated.

Report Output

The generated report contains one row for each employee. The results include:

Employee – the name of the employee that the time entry is associated with
Employee ID – the External Employee ID as defined in the user's profile
REG Hours – the number of hours paid at the regular rate
OT Hours – the number of hours paid at the overtime rate
DT Hours – the number of hours paid at the double-time rate
PTO Hours – the number of hours paid at the Paid Time Off rate
On Site – the number of hours worked on-site
Total – the total number of hours for the specified day

TimeCard Cost Detail

The TimeCard Cost Detail report lists the number of hours employees spent on work orders and manually entered time along with the activity and cost details associated with these hours.

Report Criteria

To refine your results, specify any of the following criteria. If no criteria are specified, the report will be run all values.

Region – Select a value to run the report for a particular region. Selecting a region limits the property values that can be selected to the properties within the specified region.
Property – Select a value to run the report for a particular property. If a region was selected, only properties within that region are displayed.
Company – Click the link to run the report for a particular company.
Employee – Select a name from the drop-down menu to run the report for a particular employee.
Cost Center – Enter a value to run the report for a particular cost center. The value you enter must exactly match a valid cost center as specified on the Enter Hours page.
User Group – Select a value from the drop-down menu to run the report for a particular group of users.
Date Range – Select the date range for which the report will be run. The system uses the previous week as the default date range.
Display Rates as – Select a value from the drop-down menu to run the report using either internal or standard rates.

Report Output

The generated report contains one row for each timecard entry. The results include:

Employee – the name of the employee that the time entry is associated with
Employee ID – the External Employee ID as defined in the user's profile
Work Order – the work order the time entry is associated with, or no value if the entry is for manually entered time
Property – the property that the time entry is associated with
Comment – the comment entered when the time entry was made
Date – the date on which the time entry was made
Activity – the activity selected when the time entry was made
Billable – Yes if the time entry is billable
Cost Center – the cost center selected when the time entry was made, or, if no selection was made, the automatic cost center
Service Type – the service type associated with the work order type (as defined on the Request Types and SubTypes Admin page), or NA if the entry is for manually entered time
Type – the work type as specified on the work order, or NA if the entry is for manually entered time
SubType – the work subType as specified on the work order, or NA if the entry is for manually entered time
Statement of Work – the statement of work as specified on the work order, or no value if the entry is for manually entered time
Origination Code – the code specified on the Create Request page indicating where the work order originated from, or NA if the entry is for manually entered time
Failure Code – the failure code selected when the work order was closed, or NA if no failure code was specified or if the entry was for manually entered time
REG Hours – the number of hours paid at the regular rate
OT Hours – the number of hours paid at the overtime rate
DT Hours – the number of hours paid at the double-time rate
PTO Hours – the number of hours paid at the Paid Time Off rate
Total Hours – the total number of hours of all types worked during the specified date range

REG Cost – the cost of the hours paid at the regular rate
OT Cost – the cost of the hours paid at the overtime rate
DT Cost – the cost of the hours paid at the double-time rate
PTO Cost – the cost of the hours paid at the Paid Time Off rate
Total Cost – the total cost of the hours of all types worked during the specified date range

TimeCard Hours by Employee by Project

The TimeCard Hours by Employee by Project lists the weekly number of hours spent on individual projects during the specified date range.

Report Criteria

To refine your results, specify any of the following criteria. If no criteria are specified, the report will be run for all values.

Region – Select a value to run the report for a particular region. Selecting a region limits the property values that can be selected to the properties within the specified region.
Property – Select a value to run the report for a particular property. If a region was selected, only properties within that region are displayed.
Company – Click the link to run the report for a particular company.
Employee – Select a name from the drop-down menu to run the report for a particular employee.
Cost Center – Enter a value to run the report for a particular cost center. The value you enter must exactly match a valid cost center as specified on the Enter Hours page.
User Group – Select a value from the drop-down menu to run the report for a particular group of users.
Date Range – Select the date range for which the report will be run. The system uses the previous week as the default date range.

Report Output

The generated report contains one row for each combination of work order/manual time entry and Charge To account, sorted by property. The results include:

Employee Name – the name of the employee that the work is associated with
Property – the property that the time entry is associated with
Project – the project the work is associated with or no value if the work is not associated with a project
Charge To – the account that the work was charged to, or NA if the entry was not charged to an account or was for manually entered time
Work Order – the work order the time entry is associated with, or no value if the entry is for manually entered time
Week Columns – one column listed per week, where each column contains the number of hours worked on the project during that week; weeks are listed from earliest to most recent
Total – the total number of hours for the specified day

Export TimeCard Hours - PeopleSoft

The Export TimeCard Hours – PeopleSoft report exports a summary of hours worked for use with the PeopleSoft external system.

Report Criteria

To refine your results, specify any of the following criteria. If no criteria are specified, the report will be run for all values.

Region – Select a value to run the report for a particular region. Selecting a region limits the property values that can be selected to the properties within the specified region.
Property – Select a value to run the report for a particular property. If a region was selected, only properties within that region are displayed.
Company – Click the link to run the report for a particular company.
Employee – Select a name from the drop-down menu to run the report for a particular employee.
Manager – Select a name from the drop-down menu to run the report for a particular manager. The possible values are all users who have a manager relationship established with the specified employees.
Cost Center – Enter a value to run the report for a particular cost center. The value you enter must exactly match a valid cost center as specified on the Enter Hours page.
Client ID – Enter a value to include the appropriate client ID in the exported data. This value is required for the generation of an export file that can be used by PeopleSoft.
Date Range – Select the date range for which the report will be run. The system uses the previous week as the default date range.
Group ID – Enter a value to include the appropriate group ID in the exported data. This value is required for the generation of an export file that can be used by PeopleSoft.

Report Output

The generated export file contains one row for each combination of date and work type. The results include:

Client ID – the client ID as entered in the report criteria
External Payroll ID – the external payroll ID as defined in the user's profile
Date – the date on which the time entry was made
Labor Rate – the labor rate category (REG, OT, or DT)
Start Time – for work order time entries only, the value entered for Time Started
End Time – for work order time entries only, the value entered for Time Finished
Hours – the number of hours worked at the specified labor rate
Group ID – the group ID as entered in the report criteria
User ID – the user ID of the employee who performed the work

TimeCard Detailed Print

The TimeCard Detailed Print report generates timecards that include a summary of labor activities and types for multiple employees over the specified date range. The report also includes a signature area so that managers can review and approve multiple timecards at once.

Report Criteria

To refine your results, specify any of the following criteria. If no criteria are specified, the report will be run for all values.

Date Range – Select the date range for which the report will be run. The system uses the previous week as the default date range.
Employee – Select a name from the drop-down menu to run the report for a particular employee.
Include Activity Summary – Select this check box to include a summary of the timecard labor activities in the report.
Include Labor Types Detail – Select this check box to include a detailed listing of all timecard entries broken down by labor rate category, date, and activity.

Report Output

The generated HTML report contains timecard details for each employee. The results include:

TIMESHEET – a series of weekly timesheets for each employee
- Employee – the name of the employee that the timesheet is associated with
- Week 1 through N – a standard timesheet table (see TimeCard Print Time Sheet) for each week in the specified date range
ACTIVITY SUMMARY– a three column summary of all labor activities, including:
- Activity – the name of the labor activity
- Hours – the number of hours allocated to the specified activity
LABOR TYPE DETAIL – three tables (one each for REG, OT, and DT hours) listing each timecard entry, including:
- Date – the date on which the time entry was made
- Work Order – the work order the time entry is associated with, or no value if the entry is for manually entered time
- Activity – the activity selected when the time entry was made
- Type – the work type as specified on the work order, or NA if the entry is for manually entered time
- SubType – the work subType as specified on the work order, or NA if the entry is for manually entered time
- Hours – the number of hours allocated to the specified time entry
- Comments – the comments entered when the time entry was made
- Reasons – the labor reason entered when the time entry was made; some systems are not configured to use labor reasons
APPROVAL– an area for approval signatures
- Signature and Date – the section for the employee's signature and date
- Manager Signature and Date – the section for the manager's signature and date

Export Timecard Hours – Paychex

The Export Timecard Hours – Paychex report exports timecard hours to a CSV (comma-separated values) file that can be imported into Paychex payroll. The report includes a summary of timecard hours for multiple employees over the specified date range.

Report Criteria

To refine your results, specify any of the following criteria. If no criteria are specified, the report will be run for all values.

Date Range – Select the date range for which the report will be run. The system uses the previous week as the default date range.
Employee – Select a name from the drop-down menu to run the report for a particular employee.
External Payroll ID – Enter a value to run the report for a specific external payroll system ID

Report Output

The generated export file contains one row for each timecard entry. The results include:

Date – the date on which the time entry was made
External Employee ID – the external employee ID as defined in the user's profile
External Payroll ID – the external payroll ID as defined in the user's profile
Employee Last Name – the last name of the employee
Employee First Name – the first name of the employee
Project Type – the type of project the time entry is associated with
Project ID – the ID of the project the time entry is associated with
Work Order – the work order the time entry is associated with, or no value if the entry is for manually entered time
Labor Activity Code – the code that defines the type of labor activity performed (for example, training or consulting)
Hours – the number of hours worked

Run Report – TimeCard

Report Criteria

Report Output

Report Criteria

Report Output

Report Criteria

Report Output

Report Criteria

Report Output

Report Criteria

Report Output

Report Criteria

Report Output

Report Criteria

Report Output

Report Criteria

Report Output

Rate this topic: